package com.henu.service;

import java.util.List;

import org.smart4j.framework.dao.DatabaseHelper;
import org.smart4j.framework.tx.annotation.Service;


@Service
public class AppraiseService {

    public List getAppraise(int productID) {
        return DatabaseHelper
                .queryMapList(
                        "select t.id,t.orderID,t.productID,t.userID,t.userName,date_format(t.time,'%Y-%m-%d %k:%i:%S') time,t.`comment`,t.star from appraise t where t.productID = ?",
                        productID);
    }
}
